Manually updating the RFID dimension table

IMPORTANT: You cannot save format changes in dimension tables. For example, highlights, number, date, percentage, and so on.

To manually update the RFID dimension table:

1. In the RF Admin task pane, in the Tables section, click Dimension Tables > RFID.
2. Double-click Open in Spreadsheet.

3. In the Open Table in Spreadsheet dialog, select from the following options, and click OK:

   • Columns to Return – View all physical columns or only a selected column range. Additionally, you may choose to include audit columns and calculated fields.
   • Rows to Return – View all rows or only a certain number (useful if you simply want to review the table structure).
   • Data Filter – Filter table data using the standard Filter Wizard dialog.
   • Options – Additional options include applying an auto filter, opening the spreadsheet as a read-only file, or only including unused items.
4. Do one of the following:
   • To add a new record, scroll to the bottom of the list and enter data into an empty row. After you save data back to the database, the new record should appear in the proper sort order the next time the dimension table is opened.

   • To delete a record, click the drop-down in the Delete Rows cell in column B, and select Delete Row. The system deletes the record when the spreadsheet data is written back to the database. A record cannot be deleted if there is data stored with that record in the database.

     

5. After you finish making changes, on the Main ribbon tab, click Save.

6. At the confirmation prompt, click OK.